Catering market research

Table of Contents

Data upload and preparation

Primary analysis and datasets upload

The function for the preliminary analysis showed 0 duplicates, but we have a column with unique names - "id". Let's exclude this column and check the data again for duplicates.

The number of duplicates takes less than 1% from the total number of records, we can delete duplicates.

The new dataframe is shorter for 82 records.

The minimum value in the column "Number" (number of seats) is 0. Let's look at these values in more detail:

The lack of seats in cooking or a fast-food company "Шаурма, куры-гриль" looks reasonable - usually all of those are "to-go" format. Let's see what types of objects were affected by the lack of seats.

Basically, the lack of seats affected quick service points, culinary departments in stores, snack bars, buffets, etc. Nevertheless, there are restaurants, bars and cafes without seats. Since there are quite a lot of such establishments in the general array, we assume that these establishments are currently working on delivery and pickup.

Combining names for chains

It can also be seen that in the "object_name" column, not all chain establishments are listed monotonously - for example, there are names "Готовые блюда Милти" and "МИЛТИ", "Милти", which is the name of one network. We are unifying the names for the largest chains.

There are 724 unique names for the chain restaurants in the data.

The number of unique names for chain establishments has decreased from 724 to 645. We unified the names for the largest chains - at the previous step, the number of restaurants at the leader - KFC - was 155, now it is 188.

Saving the street name in a separate column

For further analysis, we will select the street name from the address in a separate column.

Data analysis

Quantity of public catering facilities by types

Cafes are the most popular type of catering. Apparently, this type of establishments is focused on representatives of the middle class and on everyday meals. In second place in terms of the number of points with a significant lag is the dining room (economy class, not so marginally), followed by a restaurant with a slight lag - an institution for business class visitors or for special occasions.

Number of non-chain restaurants and chains restaurants

There are about four times more non-chain establishments in Moscow than chain ones.

Chain and non-chain restaurants by quantity and type

Cafes, restaurants and fast-food businesses are characterized by network distribution. What is the distribution strategy chosen by chain restaurants: are there many places with a small number of seats in each or are there few points with a large number of seats?

The ratio of the number of seats and the number of establishments in the chain

The main part of the establishments is located in the range with the number of seats up to 100. Despite the economies of scale when building a logistics chain or hiring staff with a large number of seats, small outlets require less investment to open and less rent, in addition, previously it was clear from the data that some establishments work "to take away".

Average number of seats in establishments

On average, the largest number of seats are provided by canteens and restaurants. Canteens are focused on fast service and a standardized approach, while restaurants are focused on large banquets.

Top 10 streets by the number of public catering facilities

The most popular streets for catering facilities are located in the South-Western Administrative District, Southern and Western.

Streets with one catering facility

There are most streets with 1 catering facility in the Central Administrative District, East and North-East.

Distribution of the number of seats for streets with a large number of public catering facilities

The maximum number of seats from all restaurants in the dataset is 1,700, average (40 seats) significantly different from the median - 40, the third quartile is 80 places (see the section "Loading data and preparing them for analysis"). The average number of seats on the streets with the most public catering facilities is from 45 to 85.

Conclusion

  1. The cafe is a popular format of catering establishments among Moscow population. Unlike bars and canteens, this type of establishment is characterized by network distribution.

  2. We recommend not to break the trends in the market, and open establishments with no more than 50 seats - apparently, this strategy is the most promising, as it has received the most widespread. At the same time, it makes sense to open establishments with 50-80 seats on popular and busy streets (Kutuzovsky Prospekt, Vernadsky Avenue, Leninsky Prospekt, Mira Avenue, etc.).

  3. There are still many streets in the city with 1 catering facility. It is necessary to carefully study the North-Eastern Administrative District as a promising one for opening new points.

  4. It is necessary, if possible, to supplement the market analysis with data on the passability of establishments, the period of existence and the average check.